Release notes

You can download a PDF version of the release notes here.

Summary

Kaufman Hall is pleased to announce the 2020.3 release of Axiom RPPS. Each product release provides new features, enhancements, and configuration options to meet your needs. Many of these features and enhancements are a direct result of your feedback and suggestions.

Summary of the upgrade process:

  1. Back up Axiom database – Kaufman Hall will confirm that you have a current backup of your Axiom database before applying the upgrade.

  2. Complete manual updates – After installing the upgrade, if needed, review any manual setup steps needed to enable features for this version.

Escalating to Axiom Support

As always, we appreciate your commitment to Kaufman Hall. If you have any questions about your upgrade, please contact us by logging into Axiom, clicking Help, then clicking Support.

Help and Training

Kaufman Hall provides world-class resources at your fingertips directly within the Axiom Software system. Axiom Help provides topics, knowledge base articles, documents, webinar/training announcements, and videos to guide you through managing your system. To access these resources, do any of the following:

  • Online help - From the Main or Admin ribbon tab, click Online Help, and then select the product. Axiom Help opens in a new browser window.

    NOTE: The online help will only open for products you are licensed to use.

  • Contextual help - Form/web-enabled features include contextual help directly within the user interface. This information provides a quick summary and/or instructions specifically related to the screen you are using. You can access this information by clicking the question mark in the upper right corner of the screen. For more detailed information, open Axiom Help by clicking Open Help at the top of the contextual help dialog.

Product upgrade notes

IMPORTANT: You must apply the Axiom Software 2020.3 upgrade before applying any 2020.3 Axiom product upgrades. Axiom Software upgrades are backwards compatible so you can upgrade different products at different times, but you must upgrade to the Axiom Software 2020.3 before the first product upgrade. Refer to the Axiom Software 2020.3 Release Notes and Axiom Healthcare Suite 2020.3 Release Notes for considerations before upgrading.

When upgrading to the 2020.3 version of Axiom Relationship Profitability and Pricing System, keep in mind the following:

  • This product upgrade contains updated templates, calculation methods, updated drivers, and remediated defects.
  • This product upgrade contains updated templates, calculation methods, and remediated defects.
  • KHA delivered reports may be replaced. Any report that you saved under a different name or created new will remain untouched. Replaced reports are available in Document History, if needed.
  • Any KHA delivered report that was moved to a new location will automatically move back to its original location.
  • KHA product templates and calculation method libraries will be replaced.
  • Product task panes will be replaced.
  • Process definitions will not be replaced.
  • Driver files will be replaced.
  • Security roles and sub-systems will be reset to their configured settings. All user security exceptions you may have made will remain intact.
  • Specific items configured as part of your company or organization's implementation such as imports, exports, driver files, and process management files, will remain as is. Any required modifications to these areas are covered in the release notes, if required.

New features summary

See What's New.

Known issues resolved

The following table lists the resolutions for issues addressed in 2020.3:

Issue description Description
Security: Import Users not functioning [TFS 39823] Symptom: On the Security page in the options bar, there is an option named "Import Users". This is non-functioning and is not on the roadmap for immediate implementation.

Resolution: Corrected by removing link to Import Users.
PFB-08083 - Reports: Validate Projected Profit incorrect button label and report header [TFS 39589] Symptom: The label on the button to invoke the Projected Profitability Historic Trend report is incorrect. The label should read "Validate Projected Profitability - Historic Trend". The report header is also incorrect.

Resolution: Corrected by updating the button label and header text.
PFB-07842 - Pricing: Prospective Relationship Comparison Current Portfolio includes Unassigned if Rel Admin role [TFS 39778] Symptom: If a user is assigned the Relationship Administrator role when pricing a prospective relationship, the comparison page is pulling in all the unassigned accounts.

Resolution: Corrected by adding logic to the Compare sheet filter so that it does not bring in unassigned relationships.
PFB-08108 - Pricing: New Deposit - Discount from Standard Fees populated with 25% when edited [TFS 39779] Symptom: When creating a pricing request with a new Deposit account, the Discount from Standard Fees field gets populated with 25% when the account is edited/reopened.

Resolution: Corrected by updating the PricingRequest template.
Pricing: Scenario Comparison truncates Scenario Description [TFS 39782] Symptom:The user creates a Pricing Request with multiple scenarios and changes the Scenario name to make it longer than 20 characters then when viewing the Scenario Comparison screen, the Scenario description is truncated.

Resolution: Corrected updating the Pricing Request Compare sheet scenario description from a cell reference to a Formatted cell which can span two columns.
Pricing: Fee-Based New Accounts - Origination and Maintenance Cost not calculated [TFS 39784] Symptom: When creating a Pricing Request and adding a 'Fee-Based' new account, the values for Origination Cost and Maintenance (Fixed) are not being calculated. 

Resolution: Corrected by updating logic in the Pricing Request Cashflowcalc sheet.
Pricing: Scenario Results Total Costs not summed [TFS 39785] Symptom: When a Pricing Request is created and new accounts are added to a scenario, the total costs are not being summed correctly in the New Accounts results section.

Resolution: Corrected by updating the Pricing Scenario Template total cost line in the NewAccounts form so that the cell sums up the above costs
Security: Cannot delete a user from a role [TFS 39786] Symptom: When creating a Pricing Request and adding a 'Fee-Based' new account, the values for Origination Cost and Maintenance (Fixed) are not being calculated. 

Resolution: Corrected by editing the save logic so that the active row is saved and removed Save on Submit for the formatted grid and instead use the OK button in the dialog box to drive the save.
Pricing: Not able to create Pricing request for existing relationships if Relationship Administrator [TFS 40078] Symptom:When a user assigned to the Relationship Administrator and the Pricing Requester roles (without Axiom Administrator), attempts to open any existing pricing request, an error message displays saying they do not have the correct security permission to access the pricing request.

Resolution: Corrected by updating the Pricing Requester security filter logic.
Analytical Reports: Decile by RM - should use Total Capital fields instead of only Allocated [TFS 40104] Symptom: Analytical Reports: Decile by RM - should use Total Capital fields instead of only Allocated

Resolution: Corrected by changing the title and field def of report to be Total Capital instead of Allocated Capital
PFB-07853 - Projected Profitability: Deposits with negative balances are excluded from calculations [TFS 40219] Symptom: Deposit accounts with zero or negative balances are being excluded from projected profitability calculations.

Resolution: Corrected by updating filters in CashFlowForecaster and RPPS Run CashFlowForecaster.
In My Portfolio, the columns displaying 12 Month Capital for the Relationship and for Customers is incorrectly formatted. [TFS 40270] Symptom: In My Portfolio, the columns displaying 12 Month Capital for the Relationship and for Customers is incorrectly formatted.

Resolution: Corrected by updating formatting in My Portfolio.
PFB-08121 - Imports that use RDC should retain the settings upon upgrading. [TFS 40333] Symptom: An error displays when running the Data Import CIF job because the remote data connection settings are reverted upon upgrading.

Resolution: Corrected by modifying seven data import utilities to ensure that {DefaultRemoteDataConnection} is now the default source drop down for the following import:

• Import Instruments-CDs

• Import Instrument- Credit Cards

• Import Instrument- Deposits

• Import Instrument- FeeBased

• Import Instrument- Loans

• Import Instrument- RPPS Import CIF Data

• Import Instrument- RPPS Publish CIF Data
Pricing: Account Recap Report does not open to the selected Account [TFS 40370] Symptom: In a Pricing Request in the area for existing accounts, there is an icon that links to the Account Recap report. Clicking on this icon takes the user to the Account Recap report but it is always the same account.

Resolution: Corrected by updating the Selected Value field.
Reports: Relationship Summary Issues [TFS 40438] Symptom: There are multiple issues with the Relationship Summary report. These include: Fee-Based accounts reporting metric is not displayed; Fee-Based account in Account Contribution section has irrelevant data; Provision and Non-Interest Income in Account Contribution section is not formatted correctly; Provision in Account Contribution section only applies to Loans and should be blank for deposits and fee-based; Risk Rate should be a text field in Account Detail section; customer should be displayed only once in the Account Detail section.

Resolution: Corrected by updating multiple fields.
Validate Projected Profitability - Historic Trend report Select Source Table filter [TFS 40506] Symptom: The Select Source Table filter drop-down is missing a Fee-Based option.

Resolution: Corrected by adding Fee-Based to the list choices.
Pricing: Submitted Pricing Request has incorrect RAROC Graph [TFS 40625] Symptom: If a Pricing Request has a submitted scenario then the RAROC graph is incorrect for Existing Accounts and Total Relationship. The issue appears when the user reopens the Pricing Request. When it is first submitted if the user does not leave the page then the graph is correct.

Resolution: Corrected by editing the Accounts sheet of Pricing Request to query FTM_TotalCapital.
Scenario Comparison on Pricing: Duplicating Scenario shows different data [TFS 39652] Symptom: Scenario Comparison displays different data for duplicate pricing requests.

Resolution: Corrected by updating the Pricing Request template with logic to save data from the cashflow calc directly.
PFB-07979 - Reports: Validation Current Profitability Trend - Missing Trend Data and Compare Error [TFS 39660] Symptom: All four Validation reports located on the Profitability Calculations page are failing. The reports are not displaying historical data and the sum comparison is displaying an error.

Resolution: Corrected by updating all references to the new column names.
Account Detail Report - Not opening to As of Published Date [TFS 39663] Symptom: The Account Detail Report is not opening with data as of the Published Date.  It is opening with data from the first period of source data. The user has to go into the filter and select the correct date and apply that date.

Resolution: Corrected by updating the default RefreshVariable value to Publish Date.
PFB-07840 - Projected Profitability: Incorrectly uses Sum of 12 prior Commitment amount [TFS 39665] Symptom: The Commitment amount is inflated by the number of months of data in the system.

Resolution: Corrected by removing the Commitment row from the Import.
Default Data: RPPSGlobalValues needs default record for Credit Risk Allocation [TFS 39672] Symptom: The table RPPSGlobalValues should be populated with a default record for Lookup = "Credit Risk Allocation" and Value = "Expense".

Resolution: Corrected by adding a new row for CreditRiskAllocation in the save for Default values.
PFB-08109 - Publish Job Fails - Incorrect Mapping Types in Publish ETLs for Rank and Customer_Since [TFS 39674] Symptom: The publish job fails due to incorrect mapping types.

Resolution: Corrected by updating the ranking fields in the publish relationship trend ETL to integer 32, and updated the CIFTrend table's Customer Since column to a Date format even though the field is not mapped.
Validation Report: Data is not displaying for the selected YRMO from the filter if not the Processing Date [TFS 39322] Symptom: Validation Report and Current Profitability Historical Trend Report are not displaying the top line of trend data if the user uses the filter to select a date that is different to the current processing date. 

Resolution: Corrected by updating the primary table.
Import: Fee Based has wrong default Source File Desc [TFS 39216]

Symptom: The Fee-Based import ETL has the wrong default Source File Description variable value. The ETL has it set to "CDs". The Scheduler Job correctly sets it to "FeeBased". This is only an issue if the ETL is run from the Axiom Client - which many clients are doing until configurable imports are implemented.

Resolution: Corrected by changing the variable choice for varSourceFileDesc to "FeeBased" in the ETL Import Instruments-FeeBased
Account Detail Report: Row Header Title is incorrect - Inc and Exp Detail [TFS 39221]

Symptom: On the Fee Based Account Detail Report, Income and Expense Detail, the row header title under Non-Interest Income should be "Fees". It is now "Other Loan Fees" which is incorrect. In the page header, the Expense Base is blank and should contain a value of either Fee Income or the label associated with the Reporting Metric.

Resolution: Corrected by updating label and page headers.
PFB-07947 - Fee-Based Config: Deleting Fee-Based Report Group did not delete from Capital or Expense [TFS 38335] Symptom: A deleted Fee-Based report group is not being deleted from Capital Allocation groups and Expense Allocation groups.

Resolution: Corrected by adding a scheduled job and an ETL to handle deleting CostGroups and CapitalGroups when FeeBased Report Groups are deleted.
PFB-07896 - Rel Recalc: New Relationships are not added to the RelationshipTrend table during recalc [TFS 37759]

Symptom: When a Relationship is built, it initiates the Relationship recalc process. This process should update the data in the Relationship and the RelationshipTrend table with the latest relationship metrics. The process updates the Relationship table but not the RelationshipTrend table for the new relationships.

Resolution: Corrected by editing the RelationshipTrend - Metrics Re-Calculation ETL to insert new relationships into the RelationshipTrend table.
PFB-07767 - RPPS Interest Rate Setup Default Rates (15 Year FHLB) [TFS 37788]

Symptom: In the default settings in a new RPPS system, the Term is not set correctly for the 15 year FHLB rate. This is under Current Rates > Interest Rate Set Up.

Resolution: Corrected by updating the Populate Reference Tables.
PFB-07854 - Capital: Deposits with negative balances are allocated negative Capital [TFS 36885]

Symptom: Deposits with negative balances should not be assigned negative capital.  This is incorrectly reducing the capital allocation for the account and the relationship.   

Resolution: Corrected by updating the Calculate Capital Allocation - Deposits ETL so that the average balances are absolute values which eliminates the negative balances creating negative capital.
PFB-07855 - Costs/Expenses: Deposits with negative balances are allocated negative Variable Maintenance [TFS 36888]

Symptom: Deposit instruments with negative average balances are allocated a negative Variable Maintenance expense.

Resolution: Corrected by editing the transform which assigns the variable maintenance so that the average balance (AX_Bal) is always positive when used in the calculation of maintenance variable.
Imports: Loans and CDs - Need check for blank Source Sys Desc [TFS 34574]

Symptom: The source data imports for Loans and CDs are not checking for a blank Source System Description field prior to concatenating it with the Native Interest Index. This will cause the native interest index to be "_Prime" with a leading underscore.

Resolution: Corrected by editing the Loans and CDs imports to accommodate blank source system descriptions
PFB-07897 - Pricing: Rel Manager and owner display is mismatched [TFS 36585] Symptom: The Pricing Request page has the current user incorrectly identified as the Relationship Manager.

Resolution: Corrected by editing Relationship Manager reference.
DQA Report: DQA Drill Log Displays wrong date in header [TFS 34996] Symptom: When drilling into the DQA report the date in the header of the DQA Log Drill report is incorrect. 

Resolution: Corrected by editing the control form.
My Portfolio: The Dashboard stops refreshing if select a CIF or Account [TFS 31305] Symptom: In My Portfolio, the dashboard at the top of the display stops refreshing if the user selects a customer or account.

Resolution: Corrected by a platform resolution.

Manual setup instructions

There are no manual setup or configuration steps required for this release.